package tgc.edu.tms.repository;

import java.util.List;

import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;

import tgc.edu.tms.custom.CommonRepository;
import tgc.edu.tms.entity.Classroom;

@Repository
public interface ClassroomRepository extends CommonRepository<Classroom, Integer>{

	@Query(value="SELECT DISTINCT floor FROM classroom WHERE location_id=?1",nativeQuery=true)
	public  List<String> findByLocationId(Integer id);
	
	public  Classroom findBySerialNumber(String serialNumber);

}
